Profiling Report

Dataset statistics

Number of variables	24
Number of observations	6743404
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	31
Duplicate rows (%)	< 0.1%
Total size in memory	6.0 GiB
Average record size in memory	955.0 B

Variable types

DateTime	1
Numeric	10
Categorical	8
Text	5

Alerts

Dataset has 31 (< 0.1%) duplicate rows	Duplicates
`distance_type` is highly imbalanced (64.0%)	Imbalance
`delay_carrier` is highly skewed (γ1 = 22.75356143)	Skewed
`delay_weather` is highly skewed (γ1 = 45.85829053)	Skewed
`delay_nas` is highly skewed (γ1 = 22.64631668)	Skewed
`delay_security` is highly skewed (γ1 = 288.4643263)	Skewed
`dep_delay` has 314587 (4.7%) zeros	Zeros
`arr_delay` has 124753 (1.9%) zeros	Zeros
`delay_carrier` has 5955514 (88.3%) zeros	Zeros
`delay_weather` has 6671405 (98.9%) zeros	Zeros
`delay_nas` has 6082619 (90.2%) zeros	Zeros
`delay_security` has 6735256 (99.9%) zeros	Zeros
`delay_lastaircraft` has 6032286 (89.5%) zeros	Zeros

Reproduction

Analysis started	2024-06-17 11:51:53.295062
Analysis finished	2024-06-17 11:53:57.198842
Duration	2 minutes and 3.9 seconds
Software version	ydata-profiling v4.8.3
Download configuration	config.json

flightdate
Date

Distinct	365
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	51.4 MiB

Minimum	2023-01-01 00:00:00
Maximum	2023-12-31 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

day_of_week
Real number (ℝ)

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.9827933

Minimum	1
Maximum	7
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	51.4 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	4
Q3	6
95-th percentile	7
Maximum	7
Range	6
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	2.0017618
Coefficient of variation (CV)	0.50260249
Kurtosis	-1.2323597
Mean	3.9827933
Median Absolute Deviation (MAD)	2
Skewness	0.011062589
Sum	26857584
Variance	4.0070504
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
5	1003622	14.9%
4	998363	14.8%
1	996633	14.8%
7	984934	14.6%
3	951327	14.1%
2	937570	13.9%
6	870955	12.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	996633	14.8%
2	937570	13.9%
3	951327	14.1%
4	998363	14.8%
5	1003622	14.9%
6	870955	12.9%
7	984934	14.6%

Value	Count	Frequency (%)
7	984934	14.6%
6	870955	12.9%
5	1003622	14.9%
4	998363	14.8%
3	951327	14.1%
2	937570	13.9%
1	996633	14.8%

airline
Categorical

Distinct	15
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	495.2 MiB

Southwest Airlines Co.	1421238
Delta Air Lines Inc	972931
American Airlines Inc.	928058
United Air Lines Inc.	720032
Skywest Airlines Inc.	664861
Other values (10)	2036284

Length

Max length	28
Median length	22
Mean length	19.998374
Min length	12

Characters and Unicode

Total characters	134857118
Distinct characters	37
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Endeavor Air
2nd row	Endeavor Air
3rd row	Endeavor Air
4th row	Endeavor Air
5th row	Endeavor Air

Common Values

Value	Count	Frequency (%)
Southwest Airlines Co.	1421238	21.1%
Delta Air Lines Inc	972931	14.4%
American Airlines Inc.	928058	13.8%
United Air Lines Inc.	720032	10.7%
Skywest Airlines Inc.	664861	9.9%
Republic Airways	286490	4.2%
JetBlue Airways	267915	4.0%
Spirit Air Lines	258838	3.8%
Alaska Airlines Inc.	242643	3.6%
American Eagle Airlines Inc.	224695	3.3%
Other values (5)	755703	11.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
inc	4006521	19.0%
airlines	3925868	18.6%
air	2263131	10.7%
lines	1951801	9.3%
southwest	1421238	6.7%
co	1421238	6.7%
american	1152753	5.5%
delta	972931	4.6%
united	720032	3.4%
skywest	664861	3.2%
Other values (11)	2590689	12.3%

Most occurring characters

Value	Count	Frequency (%)
i	15745592	11.7%
	14347659	10.6%
e	12341288	9.2%
n	12321606	9.1%
s	8760816	6.5%
r	8698818	6.5%
A	8444297	6.3%
l	6149392	4.6%
t	6014937	4.5%
c	5445764	4.0%
Other values (27)	36586949	27.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	134857118	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
i	15745592	11.7%
	14347659	10.6%
e	12341288	9.2%
n	12321606	9.1%
s	8760816	6.5%
r	8698818	6.5%
A	8444297	6.3%
l	6149392	4.6%
t	6014937	4.5%
c	5445764	4.0%
Other values (27)	36586949	27.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	134857118	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
i	15745592	11.7%
	14347659	10.6%
e	12341288	9.2%
n	12321606	9.1%
s	8760816	6.5%
r	8698818	6.5%
A	8444297	6.3%
l	6149392	4.6%
t	6014937	4.5%
c	5445764	4.0%
Other values (27)	36586949	27.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	134857118	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
i	15745592	11.7%
	14347659	10.6%
e	12341288	9.2%
n	12321606	9.1%
s	8760816	6.5%
r	8698818	6.5%
A	8444297	6.3%
l	6149392	4.6%
t	6014937	4.5%
c	5445764	4.0%
Other values (27)	36586949	27.1%

tail_number
Text

Distinct	5963
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	405.1 MiB

Length

Max length	6
Median length	6
Mean length	5.997429
Min length	2

Characters and Unicode

Total characters	40443087
Distinct characters	35
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3 ?
Unique (%)	< 0.1%

Sample

1st row	N605LR
2nd row	N605LR
3rd row	N331PQ
4th row	N906XJ
5th row	N337PQ

Value	Count	Frequency (%)
n488ha	3327	< 0.1%
n487ha	3315	< 0.1%
n486ha	3306	< 0.1%
n483ha	3222	< 0.1%
n484ha	3221	< 0.1%
n485ha	3199	< 0.1%
n479ha	3190	< 0.1%
n475ha	3160	< 0.1%
n495ha	3150	< 0.1%
n480ha	3107	< 0.1%
Other values (5953)	6711207	99.5%

Most occurring characters

Value	Count	Frequency (%)
N	9256873	22.9%
8	2779496	6.9%
7	2486728	6.1%
2	2477915	6.1%
3	2475189	6.1%
5	2146884	5.3%
1	2140191	5.3%
9	2098277	5.2%
6	2056955	5.1%
4	2047117	5.1%
Other values (25)	10477462	25.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	40443087	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
N	9256873	22.9%
8	2779496	6.9%
7	2486728	6.1%
2	2477915	6.1%
3	2475189	6.1%
5	2146884	5.3%
1	2140191	5.3%
9	2098277	5.2%
6	2056955	5.1%
4	2047117	5.1%
Other values (25)	10477462	25.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	40443087	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
N	9256873	22.9%
8	2779496	6.9%
7	2486728	6.1%
2	2477915	6.1%
3	2475189	6.1%
5	2146884	5.3%
1	2140191	5.3%
9	2098277	5.2%
6	2056955	5.1%
4	2047117	5.1%
Other values (25)	10477462	25.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	40443087	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
N	9256873	22.9%
8	2779496	6.9%
7	2486728	6.1%
2	2477915	6.1%
3	2475189	6.1%
5	2146884	5.3%
1	2140191	5.3%
9	2098277	5.2%
6	2056955	5.1%
4	2047117	5.1%
Other values (25)	10477462	25.9%

dep_airport
Text

Distinct	350
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	385.9 MiB

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	20230212
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	BDL
2nd row	BDL
3rd row	BDL
4th row	BDL
5th row	BDL

Value	Count	Frequency (%)
atl	332935	4.9%
den	284200	4.2%
dfw	280021	4.2%
ord	255071	3.8%
clt	192870	2.9%
lax	192260	2.9%
las	188206	2.8%
phx	175144	2.6%
sea	162441	2.4%
mco	161846	2.4%
Other values (340)	4518410	67.0%

Most occurring characters

Value	Count	Frequency (%)
A	2310561	11.4%
L	1868924	9.2%
S	1731888	8.6%
D	1586090	7.8%
T	1071694	5.3%
O	1033706	5.1%
C	1021112	5.0%
M	905267	4.5%
F	835550	4.1%
W	789662	3.9%
Other values (16)	7075758	35.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	20230212	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	2310561	11.4%
L	1868924	9.2%
S	1731888	8.6%
D	1586090	7.8%
T	1071694	5.3%
O	1033706	5.1%
C	1021112	5.0%
M	905267	4.5%
F	835550	4.1%
W	789662	3.9%
Other values (16)	7075758	35.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	20230212	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	2310561	11.4%
L	1868924	9.2%
S	1731888	8.6%
D	1586090	7.8%
T	1071694	5.3%
O	1033706	5.1%
C	1021112	5.0%
M	905267	4.5%
F	835550	4.1%
W	789662	3.9%
Other values (16)	7075758	35.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	20230212	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	2310561	11.4%
L	1868924	9.2%
S	1731888	8.6%
D	1586090	7.8%
T	1071694	5.3%
O	1033706	5.1%
C	1021112	5.0%
M	905267	4.5%
F	835550	4.1%
W	789662	3.9%
Other values (16)	7075758	35.0%

dep_cityname
Text

Distinct	344
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	450.5 MiB

Length

Max length	34
Median length	29
Mean length	13.045103
Min length	8

Characters and Unicode

Total characters	87968400
Distinct characters	57
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Hartford, CT
2nd row	Hartford, CT
3rd row	Hartford, CT
4th row	Hartford, CT
5th row	Hartford, CT

Value	Count	Frequency (%)
ca	729627	4.6%
tx	707555	4.5%
fl	600100	3.8%
ny	367049	2.3%
ga	357008	2.3%
san	352217	2.2%
il	351390	2.2%
chicago	338766	2.2%
new	337488	2.1%
atlanta	332935	2.1%
Other values (418)	11242964	71.5%

Most occurring characters

Value	Count	Frequency (%)
	8973695	10.2%
,	6743404	7.7%
a	6726644	7.6%
o	4843270	5.5%
e	4645987	5.3%
n	4315860	4.9%
t	4204810	4.8%
l	3879759	4.4%
i	3337094	3.8%
r	3178163	3.6%
Other values (47)	37119714	42.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	87968400	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	8973695	10.2%
,	6743404	7.7%
a	6726644	7.6%
o	4843270	5.5%
e	4645987	5.3%
n	4315860	4.9%
t	4204810	4.8%
l	3879759	4.4%
i	3337094	3.8%
r	3178163	3.6%
Other values (47)	37119714	42.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	87968400	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	8973695	10.2%
,	6743404	7.7%
a	6726644	7.6%
o	4843270	5.5%
e	4645987	5.3%
n	4315860	4.9%
t	4204810	4.8%
l	3879759	4.4%
i	3337094	3.8%
r	3178163	3.6%
Other values (47)	37119714	42.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	87968400	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	8973695	10.2%
,	6743404	7.7%
a	6726644	7.6%
o	4843270	5.5%
e	4645987	5.3%
n	4315860	4.9%
t	4204810	4.8%
l	3879759	4.4%
i	3337094	3.8%
r	3178163	3.6%
Other values (47)	37119714	42.2%

deptime_label
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	415.7 MiB

Morning	2611567
Afternoon	2363360
Evening	1557318
Night	211159

Length

Max length	9
Median length	7
Mean length	7.6383129
Min length	5

Characters and Unicode

Total characters	51508230
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Morning
2nd row	Morning
3rd row	Morning
4th row	Morning
5th row	Morning

Common Values

Value	Count	Frequency (%)
Morning	2611567	38.7%
Afternoon	2363360	35.0%
Evening	1557318	23.1%
Night	211159	3.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
morning	2611567	38.7%
afternoon	2363360	35.0%
evening	1557318	23.1%
night	211159	3.1%

Most occurring characters

Value	Count	Frequency (%)
n	13064490	25.4%
o	7338287	14.2%
r	4974927	9.7%
i	4380044	8.5%
g	4380044	8.5%
e	3920678	7.6%
M	2611567	5.1%
t	2574519	5.0%
A	2363360	4.6%
f	2363360	4.6%
Other values (4)	3536954	6.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	51508230	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
n	13064490	25.4%
o	7338287	14.2%
r	4974927	9.7%
i	4380044	8.5%
g	4380044	8.5%
e	3920678	7.6%
M	2611567	5.1%
t	2574519	5.0%
A	2363360	4.6%
f	2363360	4.6%
Other values (4)	3536954	6.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	51508230	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
n	13064490	25.4%
o	7338287	14.2%
r	4974927	9.7%
i	4380044	8.5%
g	4380044	8.5%
e	3920678	7.6%
M	2611567	5.1%
t	2574519	5.0%
A	2363360	4.6%
f	2363360	4.6%
Other values (4)	3536954	6.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	51508230	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
n	13064490	25.4%
o	7338287	14.2%
r	4974927	9.7%
i	4380044	8.5%
g	4380044	8.5%
e	3920678	7.6%
M	2611567	5.1%
t	2574519	5.0%
A	2363360	4.6%
f	2363360	4.6%
Other values (4)	3536954	6.9%

dep_delay
Real number (ℝ)

ZEROS

Distinct	1854
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12.200987

Minimum	-99
Maximum	4413
Zeros	314587
Zeros (%)	4.7%
Negative	3873058
Negative (%)	57.4%
Memory size	51.4 MiB

Quantile statistics

Minimum	-99
5-th percentile	-10
Q1	-5
median	-2
Q3	9
95-th percentile	78
Maximum	4413
Range	4512
Interquartile range (IQR)	14

Descriptive statistics

Standard deviation	55.079361
Coefficient of variation (CV)	4.5143367
Kurtosis	268.2125
Mean	12.200987
Median Absolute Deviation (MAD)	5
Skewness	12.011317
Sum	82276182
Variance	3033.736
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-5	504339	7.5%
-4	470790	7.0%
-3	455316	6.8%
-2	413304	6.1%
-6	402407	6.0%
-1	369791	5.5%
-7	340582	5.1%
0	314587	4.7%
-8	272735	4.0%
-9	202664	3.0%
Other values (1844)	2996889	44.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-99	1	< 0.1%
-72	1	< 0.1%
-68	1	< 0.1%
-59	3	< 0.1%
-55	1	< 0.1%
-53	1	< 0.1%
-52	2	< 0.1%
-51	1	< 0.1%
-50	1	< 0.1%
-49	1	< 0.1%

Value	Count	Frequency (%)
4413	1	< 0.1%
3786	1	< 0.1%
3695	1	< 0.1%
3518	1	< 0.1%
3445	1	< 0.1%
3343	1	< 0.1%
3249	1	< 0.1%
3238	1	< 0.1%
3221	1	< 0.1%
3024	1	< 0.1%

dep_delay_tag
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	373.0 MiB

0	4187645
1	2555759

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	6743404
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	4187645	62.1%
1	2555759	37.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	4187645	62.1%
1	2555759	37.9%

Most occurring characters

Value	Count	Frequency (%)
0	4187645	62.1%
1	2555759	37.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	6743404	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	4187645	62.1%
1	2555759	37.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	6743404	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	4187645	62.1%
1	2555759	37.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	6743404	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	4187645	62.1%
1	2555759	37.9%

dep_delay_type
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	429.1 MiB

Low <5min	5409737
Medium >15min	877998
Hight >60min	455669

Length

Max length	13
Median length	9
Mean length	9.7235217
Min length	9

Characters and Unicode

Total characters	65569635
Distinct characters	21
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Low <5min
2nd row	Low <5min
3rd row	Low <5min
4th row	Low <5min
5th row	Low <5min

Common Values

Value	Count	Frequency (%)
Low <5min	5409737	80.2%
Medium >15min	877998	13.0%
Hight >60min	455669	6.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
low	5409737	40.1%
5min	5409737	40.1%
medium	877998	6.5%
15min	877998	6.5%
hight	455669	3.4%
60min	455669	3.4%

Most occurring characters

Value	Count	Frequency (%)
i	8077071	12.3%
m	7621402	11.6%
	6743404	10.3%
n	6743404	10.3%
5	6287735	9.6%
L	5409737	8.3%
w	5409737	8.3%
<	5409737	8.3%
o	5409737	8.3%
>	1333667	2.0%
Other values (11)	7124004	10.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	65569635	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
i	8077071	12.3%
m	7621402	11.6%
	6743404	10.3%
n	6743404	10.3%
5	6287735	9.6%
L	5409737	8.3%
w	5409737	8.3%
<	5409737	8.3%
o	5409737	8.3%
>	1333667	2.0%
Other values (11)	7124004	10.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	65569635	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
i	8077071	12.3%
m	7621402	11.6%
	6743404	10.3%
n	6743404	10.3%
5	6287735	9.6%
L	5409737	8.3%
w	5409737	8.3%
<	5409737	8.3%
o	5409737	8.3%
>	1333667	2.0%
Other values (11)	7124004	10.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	65569635	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
i	8077071	12.3%
m	7621402	11.6%
	6743404	10.3%
n	6743404	10.3%
5	6287735	9.6%
L	5409737	8.3%
w	5409737	8.3%
<	5409737	8.3%
o	5409737	8.3%
>	1333667	2.0%
Other values (11)	7124004	10.9%

arr_airport
Text

Distinct	350
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	385.9 MiB

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	20230212
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	LGA
2nd row	LGA
3rd row	LGA
4th row	LGA
5th row	LGA

Value	Count	Frequency (%)
atl	332941	4.9%
den	283563	4.2%
dfw	279733	4.1%
ord	254775	3.8%
clt	192911	2.9%
lax	192417	2.9%
las	188243	2.8%
phx	175196	2.6%
sea	162323	2.4%
mco	161373	2.4%
Other values (340)	4519929	67.0%

Most occurring characters

Value	Count	Frequency (%)
A	2310587	11.4%
L	1868994	9.2%
S	1733227	8.6%
D	1584874	7.8%
T	1072291	5.3%
O	1032990	5.1%
C	1021074	5.0%
M	904967	4.5%
F	835174	4.1%
W	789110	3.9%
Other values (16)	7076924	35.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	20230212	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	2310587	11.4%
L	1868994	9.2%
S	1733227	8.6%
D	1584874	7.8%
T	1072291	5.3%
O	1032990	5.1%
C	1021074	5.0%
M	904967	4.5%
F	835174	4.1%
W	789110	3.9%
Other values (16)	7076924	35.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	20230212	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	2310587	11.4%
L	1868994	9.2%
S	1733227	8.6%
D	1584874	7.8%
T	1072291	5.3%
O	1032990	5.1%
C	1021074	5.0%
M	904967	4.5%
F	835174	4.1%
W	789110	3.9%
Other values (16)	7076924	35.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	20230212	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	2310587	11.4%
L	1868994	9.2%
S	1733227	8.6%
D	1584874	7.8%
T	1072291	5.3%
O	1032990	5.1%
C	1021074	5.0%
M	904967	4.5%
F	835174	4.1%
W	789110	3.9%
Other values (16)	7076924	35.0%

arr_cityname
Text

Distinct	344
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	450.5 MiB

Length

Max length	34
Median length	29
Mean length	13.045968
Min length	8

Characters and Unicode

Total characters	87974235
Distinct characters	57
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	New York, NY
2nd row	New York, NY
3rd row	New York, NY
4th row	New York, NY
5th row	New York, NY

Value	Count	Frequency (%)
ca	730230	4.6%
tx	707058	4.5%
fl	599542	3.8%
ny	366899	2.3%
ga	357014	2.3%
san	352645	2.2%
il	350948	2.2%
chicago	338319	2.2%
new	337294	2.1%
atlanta	332941	2.1%
Other values (418)	11245209	71.5%

Most occurring characters

Value	Count	Frequency (%)
	8974695	10.2%
,	6743404	7.7%
a	6727616	7.6%
o	4842443	5.5%
e	4646574	5.3%
n	4316955	4.9%
t	4205119	4.8%
l	3880082	4.4%
i	3338106	3.8%
r	3176719	3.6%
Other values (47)	37122522	42.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	87974235	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	8974695	10.2%
,	6743404	7.7%
a	6727616	7.6%
o	4842443	5.5%
e	4646574	5.3%
n	4316955	4.9%
t	4205119	4.8%
l	3880082	4.4%
i	3338106	3.8%
r	3176719	3.6%
Other values (47)	37122522	42.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	87974235	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	8974695	10.2%
,	6743404	7.7%
a	6727616	7.6%
o	4842443	5.5%
e	4646574	5.3%
n	4316955	4.9%
t	4205119	4.8%
l	3880082	4.4%
i	3338106	3.8%
r	3176719	3.6%
Other values (47)	37122522	42.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	87974235	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	8974695	10.2%
,	6743404	7.7%
a	6727616	7.6%
o	4842443	5.5%
e	4646574	5.3%
n	4316955	4.9%
t	4205119	4.8%
l	3880082	4.4%
i	3338106	3.8%
r	3176719	3.6%
Other values (47)	37122522	42.2%

arr_delay
Real number (ℝ)

ZEROS

Distinct	1880
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.6271515

Minimum	-119
Maximum	4405
Zeros	124753
Zeros (%)	1.9%
Negative	4146121
Negative (%)	61.5%
Memory size	51.4 MiB

Quantile statistics

Minimum	-119
5-th percentile	-27
Q1	-15
median	-6
Q3	9
95-th percentile	78
Maximum	4405
Range	4524
Interquartile range (IQR)	24

Descriptive statistics

Standard deviation	57.078921
Coefficient of variation (CV)	8.6128892
Kurtosis	235.04159
Mean	6.6271515
Median Absolute Deviation (MAD)	11
Skewness	10.934348
Sum	44689560
Variance	3258.0033
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-11	189215	2.8%
-10	189118	2.8%
-12	188072	2.8%
-9	185850	2.8%
-13	184325	2.7%
-8	182425	2.7%
-14	179315	2.7%
-7	176693	2.6%
-15	172031	2.6%
-6	170461	2.5%
Other values (1870)	4925899	73.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-119	1	< 0.1%
-98	1	< 0.1%
-97	1	< 0.1%
-96	1	< 0.1%
-94	1	< 0.1%
-92	2	< 0.1%
-91	1	< 0.1%
-89	1	< 0.1%
-88	1	< 0.1%
-86	5	< 0.1%

Value	Count	Frequency (%)
4405	1	< 0.1%
3795	1	< 0.1%
3680	1	< 0.1%
3502	1	< 0.1%
3424	1	< 0.1%
3337	1	< 0.1%
3246	1	< 0.1%
3241	1	< 0.1%
3237	1	< 0.1%
3063	1	< 0.1%

arr_delay_type
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	429.1 MiB

Low <5min	5403727
Medium >15min	885990
Hight >60min	453687

Length

Max length	13
Median length	9
Mean length	9.7273806
Min length	9

Characters and Unicode

Total characters	65595657
Distinct characters	21
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Low <5min
2nd row	Low <5min
3rd row	Low <5min
4th row	Low <5min
5th row	Low <5min

Common Values

Value	Count	Frequency (%)
Low <5min	5403727	80.1%
Medium >15min	885990	13.1%
Hight >60min	453687	6.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
low	5403727	40.1%
5min	5403727	40.1%
medium	885990	6.6%
15min	885990	6.6%
hight	453687	3.4%
60min	453687	3.4%

Most occurring characters

Value	Count	Frequency (%)
i	8083081	12.3%
m	7629394	11.6%
	6743404	10.3%
n	6743404	10.3%
5	6289717	9.6%
L	5403727	8.2%
w	5403727	8.2%
<	5403727	8.2%
o	5403727	8.2%
>	1339677	2.0%
Other values (11)	7152072	10.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	65595657	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
i	8083081	12.3%
m	7629394	11.6%
	6743404	10.3%
n	6743404	10.3%
5	6289717	9.6%
L	5403727	8.2%
w	5403727	8.2%
<	5403727	8.2%
o	5403727	8.2%
>	1339677	2.0%
Other values (11)	7152072	10.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	65595657	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
i	8083081	12.3%
m	7629394	11.6%
	6743404	10.3%
n	6743404	10.3%
5	6289717	9.6%
L	5403727	8.2%
w	5403727	8.2%
<	5403727	8.2%
o	5403727	8.2%
>	1339677	2.0%
Other values (11)	7152072	10.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	65595657	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
i	8083081	12.3%
m	7629394	11.6%
	6743404	10.3%
n	6743404	10.3%
5	6289717	9.6%
L	5403727	8.2%
w	5403727	8.2%
<	5403727	8.2%
o	5403727	8.2%
>	1339677	2.0%
Other values (11)	7152072	10.9%

flight_duration
Real number (ℝ)

Distinct	724
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	140.29778

Minimum	0
Maximum	795
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	51.4 MiB

Quantile statistics

Minimum	0
5-th percentile	58
Q1	87
median	124
Q3	171
95-th percentile	298
Maximum	795
Range	795
Interquartile range (IQR)	84

Descriptive statistics

Standard deviation	72.872157
Coefficient of variation (CV)	0.51941063
Kurtosis	2.4147395
Mean	140.29778
Median Absolute Deviation (MAD)	41
Skewness	1.3861561
Sum	9.460846 × 10⁸
Variance	5310.3513
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
81	53005	0.8%
82	52586	0.8%
79	52293	0.8%
80	52180	0.8%
83	51944	0.8%
78	51746	0.8%
84	51544	0.8%
77	51196	0.8%
85	51030	0.8%
76	50814	0.8%
Other values (714)	6225066	92.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
15	3	< 0.1%
16	9	< 0.1%
17	28	< 0.1%
18	36	< 0.1%
19	45	< 0.1%
20	49	< 0.1%
21	65	< 0.1%
22	81	< 0.1%
23	73	< 0.1%

Value	Count	Frequency (%)
795	1	< 0.1%
759	1	< 0.1%
749	1	< 0.1%
744	1	< 0.1%
742	2	< 0.1%
736	1	< 0.1%
735	2	< 0.1%
734	1	< 0.1%
732	1	< 0.1%
731	1	< 0.1%

distance_type
Categorical

IMBALANCE

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	483.1 MiB

Short Haul >1500Mi	5872159
Medium Haul <3000Mi	857184
Long Haul <6000Mi	14061

Length

Max length	19
Median length	18
Mean length	18.125029
Min length	17

Characters and Unicode

Total characters	122224395
Distinct characters	25
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Short Haul >1500Mi
2nd row	Short Haul >1500Mi
3rd row	Short Haul >1500Mi
4th row	Short Haul >1500Mi
5th row	Short Haul >1500Mi

Common Values

Value	Count	Frequency (%)
Short Haul >1500Mi	5872159	87.1%
Medium Haul <3000Mi	857184	12.7%
Long Haul <6000Mi	14061	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
haul	6743404	33.3%
short	5872159	29.0%
1500mi	5872159	29.0%
medium	857184	4.2%
3000mi	857184	4.2%
long	14061	0.1%
6000mi	14061	0.1%

Most occurring characters

Value	Count	Frequency (%)
0	14358053	11.7%
	13486808	11.0%
i	7600588	6.2%
M	7600588	6.2%
u	7600588	6.2%
H	6743404	5.5%
a	6743404	5.5%
l	6743404	5.5%
o	5886220	4.8%
S	5872159	4.8%
Other values (15)	39589179	32.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	122224395	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	14358053	11.7%
	13486808	11.0%
i	7600588	6.2%
M	7600588	6.2%
u	7600588	6.2%
H	6743404	5.5%
a	6743404	5.5%
l	6743404	5.5%
o	5886220	4.8%
S	5872159	4.8%
Other values (15)	39589179	32.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	122224395	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	14358053	11.7%
	13486808	11.0%
i	7600588	6.2%
M	7600588	6.2%
u	7600588	6.2%
H	6743404	5.5%
a	6743404	5.5%
l	6743404	5.5%
o	5886220	4.8%
S	5872159	4.8%
Other values (15)	39589179	32.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	122224395	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	14358053	11.7%
	13486808	11.0%
i	7600588	6.2%
M	7600588	6.2%
u	7600588	6.2%
H	6743404	5.5%
a	6743404	5.5%
l	6743404	5.5%
o	5886220	4.8%
S	5872159	4.8%
Other values (15)	39589179	32.4%

delay_carrier
Real number (ℝ)

SKEWED ZEROS

Distinct	1650
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.1698036

Minimum	0
Maximum	3957
Zeros	5955514
Zeros (%)	88.3%
Negative	0
Negative (%)	0.0%
Memory size	51.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	23
Maximum	3957
Range	3957
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	36.457324
Coefficient of variation (CV)	7.0519746
Kurtosis	861.84351
Mean	5.1698036
Median Absolute Deviation (MAD)	0
Skewness	22.753561
Sum	34862074
Variance	1329.1364
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	5955514	88.3%
1	25940	0.4%
2	25697	0.4%
3	24727	0.4%
6	24624	0.4%
4	23830	0.4%
15	23740	0.4%
7	22964	0.3%
5	22733	0.3%
8	21392	0.3%
Other values (1640)	572243	8.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	5955514	88.3%
1	25940	0.4%
2	25697	0.4%
3	24727	0.4%
4	23830	0.4%
5	22733	0.3%
6	24624	0.4%
7	22964	0.3%
8	21392	0.3%
9	20398	0.3%

Value	Count	Frequency (%)
3957	1	< 0.1%
3786	1	< 0.1%
3502	1	< 0.1%
3424	1	< 0.1%
3337	1	< 0.1%
3246	1	< 0.1%
3221	1	< 0.1%
3045	1	< 0.1%
3024	1	< 0.1%
2998	1	< 0.1%

delay_weather
Real number (ℝ)

SKEWED ZEROS

Distinct	1073
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.7428505

Minimum	0
Maximum	1860
Zeros	6671405
Zeros (%)	98.9%
Negative	0
Negative (%)	0.0%
Memory size	51.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	1860
Range	1860
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	14.353928
Coefficient of variation (CV)	19.322768
Kurtosis	2949.5067
Mean	0.7428505
Median Absolute Deviation (MAD)	0
Skewness	45.858291
Sum	5009341
Variance	206.03525
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	6671405	98.9%
15	1453	< 0.1%
16	1340	< 0.1%
6	1325	< 0.1%
17	1298	< 0.1%
7	1269	< 0.1%
18	1258	< 0.1%
10	1241	< 0.1%
19	1238	< 0.1%
8	1226	< 0.1%
Other values (1063)	60351	0.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	6671405	98.9%
1	1114	< 0.1%
2	1188	< 0.1%
3	1168	< 0.1%
4	1140	< 0.1%
5	1104	< 0.1%
6	1325	< 0.1%
7	1269	< 0.1%
8	1226	< 0.1%
9	1183	< 0.1%

Value	Count	Frequency (%)
1860	1	< 0.1%
1747	1	< 0.1%
1738	1	< 0.1%
1728	1	< 0.1%
1653	1	< 0.1%
1643	1	< 0.1%
1609	1	< 0.1%
1561	1	< 0.1%
1529	1	< 0.1%
1522	1	< 0.1%

delay_nas
Real number (ℝ)

SKEWED ZEROS

Distinct	837
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.566957

Minimum	0
Maximum	1708
Zeros	6082619
Zeros (%)	90.2%
Negative	0
Negative (%)	0.0%
Memory size	51.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	16
Maximum	1708
Range	1708
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	15.004842
Coefficient of variation (CV)	5.8453812
Kurtosis	1142.3422
Mean	2.566957
Median Absolute Deviation (MAD)	0
Skewness	22.646317
Sum	17310028
Variance	225.14529
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	6082619	90.2%
1	36929	0.5%
2	26309	0.4%
15	25623	0.4%
3	24666	0.4%
16	23136	0.3%
4	23077	0.3%
5	21730	0.3%
17	21260	0.3%
6	20248	0.3%
Other values (827)	437807	6.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	6082619	90.2%
1	36929	0.5%
2	26309	0.4%
3	24666	0.4%
4	23077	0.3%
5	21730	0.3%
6	20248	0.3%
7	19252	0.3%
8	18386	0.3%
9	17266	0.3%

Value	Count	Frequency (%)
1708	1	< 0.1%
1660	1	< 0.1%
1651	1	< 0.1%
1515	1	< 0.1%
1487	1	< 0.1%
1421	1	< 0.1%
1409	2	< 0.1%
1407	1	< 0.1%
1402	1	< 0.1%
1401	1	< 0.1%

delay_security
Real number (ℝ)

SKEWED ZEROS

Distinct	201
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.030648764

Minimum	0
Maximum	1460
Zeros	6735256
Zeros (%)	99.9%
Negative	0
Negative (%)	0.0%
Memory size	51.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	1460
Range	1460
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.6289231
Coefficient of variation (CV)	53.148083
Kurtosis	179570.77
Mean	0.030648764
Median Absolute Deviation (MAD)	0
Skewness	288.46433
Sum	206677
Variance	2.6533904
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	6735256	99.9%
15	333	< 0.1%
10	293	< 0.1%
16	291	< 0.1%
17	283	< 0.1%
8	270	< 0.1%
7	258	< 0.1%
12	257	< 0.1%
18	257	< 0.1%
9	256	< 0.1%
Other values (191)	5650	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	6735256	99.9%
1	184	< 0.1%
2	182	< 0.1%
3	200	< 0.1%
4	186	< 0.1%
5	243	< 0.1%
6	245	< 0.1%
7	258	< 0.1%
8	270	< 0.1%
9	256	< 0.1%

Value	Count	Frequency (%)
1460	1	< 0.1%
1183	1	< 0.1%
885	1	< 0.1%
808	1	< 0.1%
805	1	< 0.1%
600	1	< 0.1%
581	1	< 0.1%
449	1	< 0.1%
376	1	< 0.1%
373	1	< 0.1%

delay_lastaircraft
Real number (ℝ)

ZEROS

Distinct	1349
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.6811076

Minimum	0
Maximum	3581
Zeros	6032286
Zeros (%)	89.5%
Negative	0
Negative (%)	0.0%
Memory size	51.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	33
Maximum	3581
Range	3581
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	30.446469
Coefficient of variation (CV)	5.3592487
Kurtosis	537.39882
Mean	5.6811076
Median Absolute Deviation (MAD)	0
Skewness	16.353585
Sum	38310004
Variance	926.98747
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	6032286	89.5%
15	17684	0.3%
16	16691	0.2%
17	15950	0.2%
18	15240	0.2%
19	14258	0.2%
20	13982	0.2%
21	13288	0.2%
14	12685	0.2%
22	12380	0.2%
Other values (1339)	578960	8.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	6032286	89.5%
1	9092	0.1%
2	9550	0.1%
3	9331	0.1%
4	9511	0.1%
5	9753	0.1%
6	10693	0.2%
7	10528	0.2%
8	10884	0.2%
9	10977	0.2%

Value	Count	Frequency (%)
3581	1	< 0.1%
3228	1	< 0.1%
2586	1	< 0.1%
2557	1	< 0.1%
2530	1	< 0.1%
2366	1	< 0.1%
2329	1	< 0.1%
2325	1	< 0.1%
2277	1	< 0.1%
2258	1	< 0.1%

manufacturer
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	415.9 MiB

BOEING	3122320
AIRBUS	1981786
EMBRAER	949752
CANADAIR REGIONAL JET	689543
DIAMOND AIRCRAFT	3

Length

Max length	21
Median length	6
Mean length	7.6746627
Min length	6

Characters and Unicode

Total characters	51753351
Distinct characters	18
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	CANADAIR REGIONAL JET
2nd row	CANADAIR REGIONAL JET
3rd row	CANADAIR REGIONAL JET
4th row	CANADAIR REGIONAL JET
5th row	CANADAIR REGIONAL JET

Common Values

Value	Count	Frequency (%)
BOEING	3122320	46.3%
AIRBUS	1981786	29.4%
EMBRAER	949752	14.1%
CANADAIR REGIONAL JET	689543	10.2%
DIAMOND AIRCRAFT	3	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
boeing	3122320	38.4%
airbus	1981786	24.4%
embraer	949752	11.7%
canadair	689543	8.5%
regional	689543	8.5%
jet	689543	8.5%
diamond	3	< 0.1%
aircraft	3	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
I	6483198	12.5%
E	6400910	12.4%
B	6053858	11.7%
A	5689719	11.0%
R	5260382	10.2%
N	4501409	8.7%
O	3811866	7.4%
G	3811863	7.4%
S	1981786	3.8%
U	1981786	3.8%
Other values (8)	5776574	11.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	51753351	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
I	6483198	12.5%
E	6400910	12.4%
B	6053858	11.7%
A	5689719	11.0%
R	5260382	10.2%
N	4501409	8.7%
O	3811866	7.4%
G	3811863	7.4%
S	1981786	3.8%
U	1981786	3.8%
Other values (8)	5776574	11.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	51753351	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
I	6483198	12.5%
E	6400910	12.4%
B	6053858	11.7%
A	5689719	11.0%
R	5260382	10.2%
N	4501409	8.7%
O	3811866	7.4%
G	3811863	7.4%
S	1981786	3.8%
U	1981786	3.8%
Other values (8)	5776574	11.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	51753351	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
I	6483198	12.5%
E	6400910	12.4%
B	6053858	11.7%
A	5689719	11.0%
R	5260382	10.2%
N	4501409	8.7%
O	3811866	7.4%
G	3811863	7.4%
S	1981786	3.8%
U	1981786	3.8%
Other values (8)	5776574	11.2%

model
Categorical

Distinct	21
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	399.2 MiB

737 NG	2703494
170/175	863338
A320	769279
A321	704641
CRJ	689543
Other values (16)	1013109

Length

Max length	10
Median length	7
Mean length	5.0740774
Min length	3

Characters and Unicode

Total characters	34216554
Distinct characters	21
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	CRJ
2nd row	CRJ
3rd row	CRJ
4th row	CRJ
5th row	CRJ

Common Values

Value	Count	Frequency (%)
737 NG	2703494	40.1%
170/175	863338	12.8%
A320	769279	11.4%
A321	704641	10.4%
CRJ	689543	10.2%
A319	390607	5.8%
717	184919	2.7%
757	156147	2.3%
A220	98132	1.5%
190/195	75262	1.1%
Other values (11)	108042	1.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
737	2720620	28.8%
ng	2703494	28.6%
170/175	863338	9.1%
a320	769310	8.1%
a321	704641	7.4%
crj	689543	7.3%
a319	390607	4.1%
717	184919	2.0%
757	156147	1.7%
a220	98132	1.0%
Other values (10)	179723	1.9%

Most occurring characters

Value	Count	Frequency (%)
7	7999171	23.4%
3	4630542	13.5%
1	3179671	9.3%
	2717101	7.9%
N	2717070	7.9%
G	2717070	7.9%
A	1995365	5.8%
0	1827501	5.3%
2	1670215	4.9%
5	1118671	3.3%
Other values (11)	3644177	10.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	34216554	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
7	7999171	23.4%
3	4630542	13.5%
1	3179671	9.3%
	2717101	7.9%
N	2717070	7.9%
G	2717070	7.9%
A	1995365	5.8%
0	1827501	5.3%
2	1670215	4.9%
5	1118671	3.3%
Other values (11)	3644177	10.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	34216554	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
7	7999171	23.4%
3	4630542	13.5%
1	3179671	9.3%
	2717101	7.9%
N	2717070	7.9%
G	2717070	7.9%
A	1995365	5.8%
0	1827501	5.3%
2	1670215	4.9%
5	1118671	3.3%
Other values (11)	3644177	10.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	34216554	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
7	7999171	23.4%
3	4630542	13.5%
1	3179671	9.3%
	2717101	7.9%
N	2717070	7.9%
G	2717070	7.9%
A	1995365	5.8%
0	1827501	5.3%
2	1670215	4.9%
5	1118671	3.3%
Other values (11)	3644177	10.7%

aicraft_age
Real number (ℝ)

Distinct	39
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	13.480626

Minimum	1
Maximum	57
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	51.4 MiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	7
median	12
Q3	20
95-th percentile	25
Maximum	57
Range	56
Interquartile range (IQR)	13

Descriptive statistics

Standard deviation	7.8914947
Coefficient of variation (CV)	0.58539525
Kurtosis	-0.73164252
Mean	13.480626
Median Absolute Deviation (MAD)	6
Skewness	0.29683421
Sum	90905310
Variance	62.275688
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=39)

Value	Count	Frequency (%)
8	403056	6.0%
5	399399	5.9%
23	379337	5.6%
10	373106	5.5%
7	355234	5.3%
9	344489	5.1%
6	330746	4.9%
2	327333	4.9%
24	313636	4.7%
18	257439	3.8%
Other values (29)	3259629	48.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	186073	2.8%
2	327333	4.9%
3	169787	2.5%
4	141338	2.1%
5	399399	5.9%
6	330746	4.9%
7	355234	5.3%
8	403056	6.0%
9	344489	5.1%
10	373106	5.5%

Value	Count	Frequency (%)
57	826	< 0.1%
56	1062	< 0.1%
48	2360	< 0.1%
39	645	< 0.1%
38	398	< 0.1%
34	9283	0.1%
33	18807	0.3%
32	34391	0.5%
31	18053	0.3%
30	27339	0.4%

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	flightdate	day_of_week	airline	tail_number	dep_airport	dep_cityname	deptime_label	dep_delay	dep_delay_type	arr_airport	arr_cityname	arr_delay	arr_delay_type	flight_duration	distance_type	manufacturer	model	aicraft_age
0	2023-01-02	1	Endeavor Air	N605LR	BDL	Hartford, CT	Morning	-3	Low <5min	LGA	New York, NY	-12	Low <5min	56	Short Haul >1500Mi	CANADAIR REGIONAL JET	CRJ	16
1	2023-01-03	2	Endeavor Air	N605LR	BDL	Hartford, CT	Morning	-5	Low <5min	LGA	New York, NY	-8	Low <5min	62	Short Haul >1500Mi	CANADAIR REGIONAL JET	CRJ	16
2	2023-01-04	3	Endeavor Air	N331PQ	BDL	Hartford, CT	Morning	-5	Low <5min	LGA	New York, NY	-21	Low <5min	49	Short Haul >1500Mi	CANADAIR REGIONAL JET	CRJ	10
3	2023-01-05	4	Endeavor Air	N906XJ	BDL	Hartford, CT	Morning	-6	Low <5min	LGA	New York, NY	-17	Low <5min	54	Short Haul >1500Mi	CANADAIR REGIONAL JET	CRJ	17
4	2023-01-06	5	Endeavor Air	N337PQ	BDL	Hartford, CT	Morning	-1	Low <5min	LGA	New York, NY	-16	Low <5min	50	Short Haul >1500Mi	CANADAIR REGIONAL JET	CRJ	10
5	2023-01-07	6	Endeavor Air	N336PQ	BDL	Hartford, CT	Morning	-10	Low <5min	LGA	New York, NY	-13	Low <5min	62	Short Haul >1500Mi	CANADAIR REGIONAL JET	CRJ	10
6	2023-01-14	6	Endeavor Air	N311PQ	LGA	New York, NY	Afternoon	-8	Low <5min	CVG	Cincinnati, OH	-31	Low <5min	117	Short Haul >1500Mi	CANADAIR REGIONAL JET	CRJ	10
7	2023-01-21	6	Endeavor Air	N917XJ	LGA	New York, NY	Afternoon	-10	Low <5min	CVG	Cincinnati, OH	-25	Low <5min	125	Short Haul >1500Mi	CANADAIR REGIONAL JET	CRJ	16
8	2023-01-28	6	Endeavor Air	N336PQ	LGA	New York, NY	Afternoon	-5	Low <5min	CVG	Cincinnati, OH	-15	Low <5min	130	Short Haul >1500Mi	CANADAIR REGIONAL JET	CRJ	10
9	2023-01-09	1	Endeavor Air	N491PX	LGA	New York, NY	Evening	-7	Low <5min	BGM	Binghamton, NY	-3	Low <5min	63	Short Haul >1500Mi	CANADAIR REGIONAL JET	CRJ	4

	flightdate	day_of_week	airline	tail_number	dep_airport	dep_cityname	deptime_label	dep_delay	dep_delay_tag	dep_delay_type	arr_airport	arr_cityname	arr_delay	arr_delay_type	flight_duration	distance_type	delay_carrier	delay_lastaircraft	manufacturer	model	aicraft_age
6743394	2023-12-31	7	JetBlue Airways	N937JB	BOS	Boston, MA	Afternoon	60	1	Medium >15min	BUF	Buffalo, NY	43	Medium >15min	80	Short Haul >1500Mi	43	0	AIRBUS	A321	10
6743395	2023-12-31	7	JetBlue Airways	N945JT	SFO	San Francisco, CA	Morning	-8	0	Low <5min	JFK	New York, NY	-14	Low <5min	326	Medium Haul <3000Mi	0	0	AIRBUS	A321	10
6743396	2023-12-31	7	JetBlue Airways	N558JB	ORH	Worcester, MA	Afternoon	-4	0	Low <5min	FLL	Fort Lauderdale, FL	-35	Low <5min	169	Short Haul >1500Mi	0	0	AIRBUS	A320	24
6743397	2023-12-31	7	JetBlue Airways	N284JB	BOS	Boston, MA	Afternoon	-5	0	Low <5min	BWI	Baltimore, MD	-20	Low <5min	85	Short Haul >1500Mi	0	0	EMBRAER	190/195	16
6743398	2023-12-31	7	JetBlue Airways	N661JB	JFK	New York, NY	Morning	20	1	Medium >15min	RSW	Fort Myers, FL	-1	Low <5min	175	Short Haul >1500Mi	0	0	AIRBUS	A320	17
6743399	2023-12-31	7	JetBlue Airways	N903JB	SJU	San Juan, PR	Morning	4	1	Low <5min	JFK	New York, NY	-33	Low <5min	219	Medium Haul <3000Mi	0	0	AIRBUS	A321	11
6743400	2023-12-31	7	JetBlue Airways	N535JB	MCO	Orlando, FL	Evening	113	1	Hight >60min	SJU	San Juan, PR	100	Hight >60min	162	Short Haul >1500Mi	4	96	AIRBUS	A320	22
6743401	2023-12-31	7	JetBlue Airways	N354JB	PHL	Philadelphia, PA	Afternoon	-11	0	Low <5min	BOS	Boston, MA	-12	Low <5min	73	Short Haul >1500Mi	0	0	EMBRAER	190/195	11
6743402	2023-12-31	7	JetBlue Airways	N768JB	PBI	West Palm Beach/Palm Beach, FL	Afternoon	-7	0	Low <5min	BDL	Hartford, CT	-30	Low <5min	158	Short Haul >1500Mi	0	0	AIRBUS	A320	15
6743403	2023-12-31	7	JetBlue Airways	N547JB	BDL	Hartford, CT	Morning	-8	0	Low <5min	PBI	West Palm Beach/Palm Beach, FL	-24	Low <5min	173	Short Haul >1500Mi	0	0	AIRBUS	A320	22

Most frequently occurring

	flightdate	day_of_week	airline	tail_number	dep_airport	dep_cityname	deptime_label	dep_delay	dep_delay_type	arr_airport	arr_cityname	arr_delay	arr_delay_type	flight_duration	distance_type	manufacturer	model	aicraft_age	# duplicates
0	2023-01-11	3	Southwest Airlines Co.	N8790Q	HNL	Honolulu, HI	Morning	0	Low <5min	ITO	Hilo, HI	-6	Low <5min	54	Short Haul >1500Mi	BOEING	737 NG	2	2
1	2023-01-12	4	Southwest Airlines Co.	N8715Q	HNL	Honolulu, HI	Morning	-2	Low <5min	LIH	Lihue, HI	-5	Low <5min	42	Short Haul >1500Mi	BOEING	737 NG	7	2
2	2023-01-23	1	Southwest Airlines Co.	N8715Q	HNL	Honolulu, HI	Morning	-3	Low <5min	ITO	Hilo, HI	-8	Low <5min	55	Short Haul >1500Mi	BOEING	737 NG	7	2
3	2023-02-27	1	Southwest Airlines Co.	N235WN	AUS	Austin, TX	Afternoon	-7	Low <5min	DAL	Dallas, TX	-22	Low <5min	50	Short Haul >1500Mi	BOEING	737 NG	18	2
4	2023-03-03	5	Southwest Airlines Co.	N8787K	HNL	Honolulu, HI	Morning	-1	Low <5min	OGG	Kahului, HI	-5	Low <5min	41	Short Haul >1500Mi	BOEING	737 NG	2	2
5	2023-03-14	2	Southwest Airlines Co.	N8546V	RIC	Richmond, VA	Afternoon	-7	Low <5min	ATL	Atlanta, GA	-15	Low <5min	97	Short Haul >1500Mi	BOEING	737 NG	7	2
6	2023-03-23	4	Skywest Airlines Inc.	N823SK	SGU	St. George, UT	Morning	-6	Low <5min	SLC	Salt Lake City, UT	-18	Low <5min	63	Short Haul >1500Mi	CANADAIR REGIONAL JET	CRJ	16	2
7	2023-04-11	2	Skywest Airlines Inc.	N823SK	SLC	Salt Lake City, UT	Afternoon	-5	Low <5min	SGU	St. George, UT	-13	Low <5min	60	Short Haul >1500Mi	CANADAIR REGIONAL JET	CRJ	16	2
8	2023-04-19	3	Skywest Airlines Inc.	N823SK	SLC	Salt Lake City, UT	Afternoon	-3	Low <5min	SGU	St. George, UT	-13	Low <5min	58	Short Haul >1500Mi	CANADAIR REGIONAL JET	CRJ	16	2
9	2023-05-06	6	Republic Airways	N824MD	CMH	Columbus, OH	Morning	-4	Low <5min	DTW	Detroit, MI	-25	Low <5min	49	Short Haul >1500Mi	EMBRAER	170/175	19	2

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)